# Run in phpMyAdmin or Whatever You're Using to Reach your Database Panel:
INSERT INTO `permissions` (`id`, `name`, `access_key`) VALUES (NULL, 'Delete Ticket', 'delete_ticket');
ALTER TABLE `tickets` ADD `feedback_type` TINYINT UNSIGNED NULL AFTER `attachment_name`, ADD `feedback` VARCHAR(500) NOT NULL AFTER `feedback_type`;
INSERT INTO `permissions` (`id`, `name`, `access_key`) VALUES (NULL, 'Edit Ticket Reply', 'edit_ticket_reply'), (NULL, 'Delete Ticket Reply', 'delete_ticket_reply'), (NULL, 'Delete Ticket Feedback', 'delete_ticket_feedback');
INSERT INTO `email_templates` (`id`, `title`, `subject`, `hook`, `language`, `template`, `is_built_in`, `updated_at`, `created_at`) VALUES (NULL, 'Ticket Feedback Shared by User', 'User Shared the Feedback to Assigned Ticket', 'ticket_feedback_shared', 'english', '<p>Hi {USER_NAME},<br><br>The user has shared the feedback to the ticket that\'s assigned to you. You can see the ticket by clicking on the following link:<br><a href=\"{TICKET_URL}\" target=\"_blank\">Click here</a><br><br>Thanks,<br>{SITE_NAME} Support<br></p>', '1', NULL, '1693640033');
INSERT INTO `settings` (`id`, `access_key`, `value`) VALUES (NULL, 'module_knowledgebase', '1'), (NULL, 'module_faqs', '1'), (NULL, 'module_announcements', '1'), (NULL, 'module_tickets', '1');
INSERT INTO `settings` (`id`, `access_key`, `value`) VALUES (NULL, 'envato_api_token', ''), (NULL, 'envato_ask_purchase_code_ticket', '0'), (NULL, 'envato_se_create_ticket', '0'), (NULL, 'envato_support_policy_url', 'https://codecanyon.net/page/item_support_policy');
INSERT INTO `permissions` (`id`, `name`, `access_key`) VALUES (NULL, 'Envato Purchase Information (Tickets & Chats)', 'envato_purchase_information');
INSERT INTO `settings` (`id`, `access_key`, `value`) VALUES (NULL, 'envato_ask_purchase_code_chat', '0'), (NULL, 'envato_se_create_chat', '0');
INSERT INTO `settings` (`id`, `access_key`, `value`) VALUES (NULL, 'envato_how_to_find_pc', 'https://help.market.envato.com/hc/en-us/articles/202822600-Where-Is-My-Purchase-Code-');
INSERT INTO `settings` (`id`, `access_key`, `value`) VALUES (NULL, 'sp_allow_ticket_feedback_delete', '1');
CREATE TABLE `tickets_envato_responses` (`id` INT UNSIGNED NOT NULL AUTO_INCREMENT, `ticket_id` INT UNSIGNED NOT NULL, `envato_purchase_code` VARCHAR(255) NOT NULL, `envato_purchase_code_response` TEXT NOT NULL, PRIMARY KEY (`id`)) ENGINE = InnoDB;
CREATE TABLE `chats_envato_responses` (`id` INT UNSIGNED NOT NULL AUTO_INCREMENT, `chat_id` INT UNSIGNED NOT NULL, `envato_purchase_code` VARCHAR(255) NOT NULL, `envato_purchase_code_response` TEXT NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB;

// If You've Added Any Permissions Other than the Default Permissions of the Script, Please Assign the Permissions to the Super Admin or Agent Roles Manually (Through the Admin Panel) Instead of Running These:
INSERT INTO `roles_permissions` (`id`, `role_id`, `permission_id`) VALUES (NULL, '1', '19');
INSERT INTO `roles_permissions` (`id`, `role_id`, `permission_id`) VALUES (NULL, '1', '20'), (NULL, '1', '21'), (NULL, '1', '22');
INSERT INTO `roles_permissions` (`id`, `role_id`, `permission_id`) VALUES (NULL, '1', '23');
INSERT INTO `roles_permissions` (`id`, `role_id`, `permission_id`) VALUES (NULL, '2', '23');